UC知道[高分求解]EXCEL IF分类
来源：百度知道 编辑：UC知道 时间：2024/06/03 17:03:43
目前手头上有些数据,分别是天数,要对应不同的利息
如下30天到89天用1个月的每天利息算,90天到179天用3个月等等,29天以下按0.004739726%算 达人给看看~
=IF("30"<E2<"89","0.005863013%",IF("90"<E2<"179","0.006328767%",IF("180"<E2<"364","0.006739726%",IF("365"<E2,"0.007150684%","0.004739726%"))))
数据
不到1个月 0.004739726%
1个月,不到3个月0.005863013%
3个月,不到半年 0.006328767%
半年,不到1年 0.006739726%
1年+ 0.007150684%
请问我做的IF命令为什么不能正确区分? 达人帮我
如下30天到89天用1个月的每天利息算,90天到179天用3个月等等,29天以下按0.004739726%算 达人给看看~
=IF("30"<E2<"89","0.005863013%",IF("90"<E2<"179","0.006328767%",IF("180"<E2<"364","0.006739726%",IF("365"<E2,"0.007150684%","0.004739726%"))))
数据
不到1个月 0.004739726%
1个月,不到3个月0.005863013%
3个月,不到半年 0.006328767%
半年,不到1年 0.006739726%
1年+ 0.007150684%
请问我做的IF命令为什么不能正确区分? 达人帮我
IF的条件只能是一个,要是多个的话就要用AND连起来,
=IF(AND(E2<89,E2>=30),"0.005863013%",IF(AND(E2<179,E2>=90),"0.006328767%",IF(AND(E2<364,E2>=180),"0.006739726%",IF(E2>=365,"0.007150684%","0.004739726%"))))
如果你的数据是是数值型的就不用双引号了，如果是文本型的才加上双引号。
---------------------------------------------------------------------
如果你要简化的话，可以这样，
=IF(E2>=365,"0.007150684%",IF(E2>=180,"0.006739726%",IF(E2>=90,"0.006328767%",IF(E2>=30,"0.005863013%","0.004739726%" ))))
=LOOKUP(A1,{0,30,90,180,365},{0.004739726%,0.005863013%,0.006328767%,0.006739726%,0.007150684% })
如果360天算一年,将公式中的365改为360即可.
你用这个公式,直接复制粘贴到你的单元格.
=IF(E2<30,0.004739726%,IF(E2<90,0.005863013%,IF(E2<179,0.006328767%,IF(E2<364,0.006739726%,0.007150684%))))
"30"<E2<"89"？大姐！excel里能这么写吗？这么写当然区分不了啊，四楼正解
=IF(E2<30,0.004739726